
#! /bin/bash
HIVE_HOME=/usr/bin/hive


${HIVE_HOME} -S -e "CREATE TABLE mysql.o_e_olap.rpt_signup_school_topn
AS SELECT * FROM hive.oe_rpt.rpt_signup_campus_topn;



CREATE TABLE mysql.o_e_olap.rpt_signup_subject_topn
AS SELECT * FROM hive.oe_rpt.rpt_signup_subject_topn;



CREATE TABLE mysql.o_e_olap.rpt_signup_all_topn
AS SELECT * FROM hive.oe_rpt.rpt_signup_all_topn1;


---------------------总报名量中来源渠道为线上访客渠道的报名总量
CREATE TABLE mysql.o_e_olap.rpt_signup_online_topn
AS SELECT * FROM hive.oe_rpt.rpt_signup_online_topn;

--------------------3.5 意向用户报名转化率
CREATE TABLE mysql.o_e_olap.rpt_signup_relation_ratio
AS SELECT * FROM hive.oe_rpt.rpt_signup_relation_ratio1;



--------------------3.6 有效线索报名转化率
CREATE TABLE mysql.o_e_olap.rpt_signup_clue_ratio
AS SELECT * FROM hive.oe_rpt.rpt_signup_clue_ratio1;


----------3.7 日报名趋势图
CREATE TABLE mysql.o_e_olap.rpt_signup_day_topn
AS SELECT * FROM hive.oe_rpt.rpt_signup_day_topn;

--------------3.8 校区学科的报名学员TOP
CREATE TABLE mysql.o_e_olap.rpt_signup_ss_topn
AS SELECT * FROM hive.oe_rpt.rpt_signup_ss_topn;


-----------3.9 来源渠道占比
CREATE TABLE mysql.o_e_olap.rpt_signup_origin_channel
AS SELECT * FROM hive.oe_rpt.rpt_signup_origin_channel;


----------------------3.10 咨询中心报名贡献
CREATE TABLE mysql.o_e_olap.rpt_signup_dept
AS SELECT * FROM hive.oe_rpt.rpt_signup_dept;

"